Error: Run-time error 100: Object...opening Excel file in Binder due macros.
Error:
Run-time error 100: Object variable not Set. Application does not have writeable Range property.
Cause:
This error occurs when opening a binder or activating a section which contains an Excel file. The Excel file was created using a Template which contains Visual Basic macros. These macros cannot be run within a Binder. Microsoft Corporation has confirmed this to be a problem in Office 95.
Solution:
Do not include an Excel file created from a template containing a macro in Office Binder. Workaround: Unbind the binder.
NOTE: If Binder hangs during the following procedure, press CTRL+ALT+DEL, select 'Microsoft Office Binders/Microsoft Excel' and click 'End Task'.
To unbind the binder:
1) Exit binder.
2) Open 'Windows Explorer' in Windows:
a) Click 'Start' todisplay the Windows 'Start' menu.
Start menu
b) Select the 'Start' menu and select 'Windows Explorer'.
3) Locate the Binder file:
a) Click 'Start' todisplay the Windows 'Start' menu.
b) Select 'Find' and select 'Files or Folders'.
c) Select 'Files or Folders...' from the submenu.
d) Click the 'Name and Location' tab.
e) Type the name of the Binder file in the 'Find What' box.
NOTE: If the complete name is not know, type *.OBD to search for all Binder files.
f) Click 'Find Now'. (The Binder file will appear in the search results window.)
4) Right-click on the binder file to display the shortcut menu.
Binder section shortcut menu
5) Select 'Unbind' from the shortcut menu.
6) Close the 'Find File' dialog box.
